﻿CREATE TABLE [dbo].[DepartamenteParametrii] (
    [IDDepartParam] INT             IDENTITY (1, 1) NOT NULL,
    [IDDepartament] INT             NOT NULL,
    [Luna]          SMALLINT        NOT NULL,
    [An]            SMALLINT        DEFAULT ((0)) NOT NULL,
    [NrPaturi]      INT             DEFAULT ((0)) NOT NULL,
    [Suprafata]     DECIMAL (18, 2) NOT NULL,
    [CodUnitate]    SMALLINT        DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_DepartamenteParametrii] PRIMARY KEY CLUSTERED ([IDDepartParam] ASC),
    CONSTRAINT [FK_DepartamenteParametrii_Departamente] FOREIGN KEY ([IDDepartament]) REFERENCES [dbo].[Departamente] ([IDDepartament]),
    CONSTRAINT [FK_DepartamenteParametrii_Unitati] FOREIGN KEY ([CodUnitate]) REFERENCES [dbo].[Unitati] ([CodUnitate])
);

